package com.ossean.databaseSource;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import com.ossean.model.OpenhubProject;
import com.ossean.model.SourceForgeProject;


public interface PartProjectDao {

	@Select("select name,description,code_repository from openhub_project where url = #{url} group by url_md5 order by extracted_time desc")
	public OpenhubProject getOpenHubPrjByUrl( @Param("url") String url);
	
	@Select("select name,description,download_num,favor_num from sourceforge_project where url = #{url} group by url_md5 order by extracted_time desc")
	public SourceForgeProject getSourceForgePrjByUrl( @Param("url") String url);
	
}
